# -*- coding: utf-8 -*-
"""
Created on Wed Apr 14 16:10:20 2021

@author: openminds
"""
import pandas as pd
import numpy as np

def myPandas(data_path,sheet_name='Sheet1'):
    # import excel file by pandas
    df = pd.read_excel(data_path,sheet_name,header=None)
    df.dropna(how='all',inplace=True) 
    df_array = np.array(df)
    rows,cols = df_array.shape
    items = {}
    for i in range(1,rows):
        items[df_array[i][0]] = f'{df_array[i][1]}'
        
    return items
     
if __name__ == "__main__":
    data_path = 'SCL-90.xlsx'
    data = myPandas(data_path)
    print(data)
